<!DOCTYPE html>
<link href="css/default.css" rel="stylesheet" type="text/css">
<html>
<head>
<meta charset="ISO-8859-1">
<title>Creating database schema with pgAdmin III</title>
</head>
<body>
<h1>Creating database schema with pgAdmin III</h1>
<ol>
	<li><a href="pgadmin_login.html">Login to openempi database if you haven't done so.</a>
	</li>
	<li>Open up <tt>Databases/openempi/Schemas/public</tt> node.
	Click on <tt>Execute arbitrary SQL queries</tt> button on the toolbar.
		Note: the picture here shows an already created schema, your schema will be empty.
		TODO: new screenshot for this.<br/>
		<img src="img/PgAdminOpenSQLScript1a.jpg" />
	</li>
	<li>In the upcoming window's toolbar click on the <tt>Open</tt> button, say <tt>No</tt> for the question about saving.<br/>
		<img src="img/PgAdminOpenSQLScript2.jpg" />
	</li>
	<li>Browse to the create database schema script:<br/>
		<img src="img/PgAdminCreateScriptOpen.jpg" />
	</li>
	<li>Click on the <tt>Execute query</tt> button on the toolbar:<br/>
		<img src="img/PgAdminCreateScriptRunStart.jpg" />
	</li>
	<li>The query should be successful:<br/>
		<img src="img/PgAdminCreateScriptRunEnd.jpg" />
	</li>
</ol>

</body>
</html>